package com.sky.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.time.LocalDateTime;

/**
 * @author 苏成博
 * @date 2023-02-15 16:14
 */
@Mapper
public interface WorkSpaceMapper {
    @Select("select sum(amount) from orders where order_time between  #{localDateTimeMin} and #{localDateTimeMax}")
    Double getTodayBusinessData(LocalDateTime localDateTimeMin, LocalDateTime localDateTimeMax);
}
